go
use RadioCabsDB
--------------------------COMPANY--------------------------
insert into Company values('ABC','Nguyen Van Bao','Assistant','So 289 Quan Ba Dinh, Ha Noi','0932747198','0437655764','0437655765','Premium',0)
insert into Company values('Mai Linh Group','Tran Van Hao','Secretary','So 123 Quan Cau Giay, Ha Noi','0932111118','0437655756','0437655709','Basic',1)
insert into Company values('My Dinh','Nguyen Thi Nham','Management','So 67 Quan Thanh Xuan, Ha Noi','0932747197','0437655712','0437655708','Premium',1)
insert into Company values('Van Xuan','Vu Van Quan','Secretary','So 2 Quan Hoang Mai, Ha Noi','0932747196','0437655714','0437655707','Free',0)
insert into Company values('Vina Taxi','Dao Hai Nam','Assistant','So 1000 Duong Lang, Ha Noi','0932747195','04376557611','0437655706','Basic',0)
insert into Company values('Vina Sun','Ho Van Hoa','Director','So 98 Duong Ho Tung Mau, Quan Tu Liem, Ha Noi','0932747115','0437655705','0437655704','Free',1)
insert into Company values('Sao Viet','Tran Thu Huong','Secretary','So 751 Quan Hai Ba Trung, Ha Noi','0932747134','0437655717','0437655703','Basic',1)
insert into Company values('Phuong Nam','Vu Quoc Dung','Management','So 34 Quan Hoan Kiem, Ha Noi','0932747123','0437655719','0437655789','Premium',0)
insert into Company values('HaNoi Tourist','Ho Hong Van','Secretary','So 123 Quan Dong Da, Ha Noi','0932747112','0437655710','0437655701','Free',1)
insert into Company values('Noi Bai Taxi','Nguyen Thi Phuong','Assistant','So 267 Quan Ha Dong, Ha Noi','0932747111','0437655720','0437655723','Basic',0)


--------------------------ACCOUNT--------------------------

insert into Account values(1, NULL, 'baonv@gmail.com', '123456', 0)
insert into Account values(2, NULL, 'haotv@gmail.com', '123456', 0)
insert into Account values(3, NULL, 'nhamnt@gmail.com', '123456', 0)
insert into Account values(4, NULL, 'quanvv@gmail.com', '123456', 0)
insert into Account values(5, NULL, 'namdh@gmail.com', '123456', 0)
insert into Account values(6, NULL, 'hoahv@gmail.com', '123456', 0)
insert into Account values(7, NULL, 'huongtt@gmail.com', '123456', 0)
insert into Account values(8, NULL, 'dungnq@gmail.com', '123456', 0)
insert into Account values(9, NULL, 'vanhh@gmail.com', '123456', 0)
insert into Account values(10, NULL, 'phuongnt@gmail.com', '123456', 0)
